/*
 * Test.java
 *
 * Created on November 16, 2007, 1:50 AM
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
 *
 * @author Minghui
 */
public class Test {
    
    /** Creates a new instance of Test 
     * @throws ClassNotFoundException 
     * @throws SQLException */
    public static void main(String[] args)
    {
//    	try {
//			Class.forName("com.mysql.jdbc.Driver");
//			Connection connection  = DriverManager.getConnection(
//					"jdbc:mysql://localhost:3306/tc", "tc",
//					"textbookcrossroads");
//			Statement statement = connection.createStatement();
			String isbn="9780262032933";
			String q3=" where isbn13="+isbn+" ";
			String title="new";
			String q1=" title="+title+" ";
			String authors="hello";
			String q2=" authors="+authors+" ";
			System.out.println("11111111111111111111111111111111");
			String query="update textbooks set "+q1+q2+q3;;
			
			System.out.println(query);
//			statement.executeUpdate(query);
//			statement.close();
//			connection.close();
//		} catch (ClassNotFoundException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//		catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
        
    }
    
}
